{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "d079a780",
   "metadata": {},
   "source": [
    "## Pandas：数据分析处理库"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "2dba783b",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "0b093a3d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel('./data/企业标签元数据v1.2.xlsx',sheet_name='生成企业现有标签',dtype=str)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "961c217e",
   "metadata": {},
   "source": [
    "## .head() 可以读取前几条数据，指定前几条都可以"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "40e4a485",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>ID</th>\n",
       "      <th>TAG_NAME</th>\n",
       "      <th>TAG_COMMENT</th>\n",
       "      <th>EFFECTIVE_DATE</th>\n",
       "      <th>INVALID_DATE</th>\n",
       "      <th>DATA_TYPE</th>\n",
       "      <th>BUSINESS_DESC</th>\n",
       "      <th>TECH_DESC</th>\n",
       "      <th>TAG_TYPE</th>\n",
       "      <th>IS_AUTHORITY</th>\n",
       "      <th>...</th>\n",
       "      <th>TABLE_NAME</th>\n",
       "      <th>TABLE_COMMENT</th>\n",
       "      <th>REPOSITORY</th>\n",
       "      <th>DOMAIN</th>\n",
       "      <th>OWNER</th>\n",
       "      <th>CREATE_DATE</th>\n",
       "      <th>IS_VALID</th>\n",
       "      <th>REMARK</th>\n",
       "      <th>RANK</th>\n",
       "      <th>VERSION</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A0097</td>\n",
       "      <td>IS_TORCH_PLAN</td>\n",
       "      <td>国家火炬计划重点高新技术企业</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“国家火...</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>97</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A0098</td>\n",
       "      <td>IS_KJSSWS</td>\n",
       "      <td>会计师事务所</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>98</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A0099</td>\n",
       "      <td>IS_KJZXJG</td>\n",
       "      <td>科技咨询机构</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>99</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A0100</td>\n",
       "      <td>IS_NSQZNXF</td>\n",
       "      <td>南山区智能消防工程技术研究中心</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“南山区...</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>100</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A0101</td>\n",
       "      <td>IS_SZSZNHYZZYCXZX</td>\n",
       "      <td>深圳市智能海洋制造业创新中心</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>101</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A0102</td>\n",
       "      <td>IS_SJQRGGQY</td>\n",
       "      <td>省机器人骨干企业</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“省机器...</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>102</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A0103</td>\n",
       "      <td>IS_SZDNYLTQY</td>\n",
       "      <td>市重点农业龙头企业</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“市重点...</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>103</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>A0104</td>\n",
       "      <td>IS_XXZXSJ</td>\n",
       "      <td>信息咨询设计</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>104</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>A0105</td>\n",
       "      <td>IS_SOFTWARE_QY</td>\n",
       "      <td>软件企业</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“软件企业”</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>105</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>A0106</td>\n",
       "      <td>IS_SZGXJSQY</td>\n",
       "      <td>深圳市高新技术企业</td>\n",
       "      <td>2020/12/27</td>\n",
       "      <td>2120/12/27 23:59:59</td>\n",
       "      <td>NUMBER</td>\n",
       "      <td>组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“深圳市...</td>\n",
       "      <td>SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...</td>\n",
       "      <td>B1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...</td>\n",
       "      <td>企业基本信息</td>\n",
       "      <td>DATASUMMARY</td>\n",
       "      <td>机构</td>\n",
       "      <td>李从志</td>\n",
       "      <td>2021/1/30 15:37:43</td>\n",
       "      <td>1</td>\n",
       "      <td>南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...</td>\n",
       "      <td>106</td>\n",
       "      <td>V1.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      ID           TAG_NAME      TAG_COMMENT EFFECTIVE_DATE  \\\n",
       "0  A0097      IS_TORCH_PLAN   国家火炬计划重点高新技术企业     2020/12/27   \n",
       "1  A0098          IS_KJSSWS           会计师事务所     2020/12/27   \n",
       "2  A0099          IS_KJZXJG           科技咨询机构     2020/12/27   \n",
       "3  A0100         IS_NSQZNXF  南山区智能消防工程技术研究中心     2020/12/27   \n",
       "4  A0101  IS_SZSZNHYZZYCXZX   深圳市智能海洋制造业创新中心     2020/12/27   \n",
       "5  A0102        IS_SJQRGGQY         省机器人骨干企业     2020/12/27   \n",
       "6  A0103       IS_SZDNYLTQY        市重点农业龙头企业     2020/12/27   \n",
       "7  A0104          IS_XXZXSJ           信息咨询设计     2020/12/27   \n",
       "8  A0105     IS_SOFTWARE_QY             软件企业     2020/12/27   \n",
       "9  A0106        IS_SZGXJSQY        深圳市高新技术企业     2020/12/27   \n",
       "\n",
       "          INVALID_DATE DATA_TYPE  \\\n",
       "0  2120/12/27 23:59:59    NUMBER   \n",
       "1  2120/12/27 23:59:59    NUMBER   \n",
       "2  2120/12/27 23:59:59    NUMBER   \n",
       "3  2120/12/27 23:59:59    NUMBER   \n",
       "4  2120/12/27 23:59:59    NUMBER   \n",
       "5  2120/12/27 23:59:59    NUMBER   \n",
       "6  2120/12/27 23:59:59    NUMBER   \n",
       "7  2120/12/27 23:59:59    NUMBER   \n",
       "8  2120/12/27 23:59:59    NUMBER   \n",
       "9  2120/12/27 23:59:59    NUMBER   \n",
       "\n",
       "                                       BUSINESS_DESC  \\\n",
       "0  组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“国家火...   \n",
       "1                                                NaN   \n",
       "2                                                NaN   \n",
       "3  组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“南山区...   \n",
       "4                                                NaN   \n",
       "5  组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“省机器...   \n",
       "6  组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“市重点...   \n",
       "7                                                NaN   \n",
       "8   组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“软件企业”   \n",
       "9  组织机构代码、单位名称匹配（表中统一社会信用代码和注册号值混乱相间），且单位特性包含“深圳市...   \n",
       "\n",
       "                                           TECH_DESC TAG_TYPE IS_AUTHORITY  \\\n",
       "0  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "1  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...      NaN          NaN   \n",
       "2  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...      NaN          NaN   \n",
       "3  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "4  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...      NaN          NaN   \n",
       "5  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "6  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "7  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...      NaN          NaN   \n",
       "8  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "9  SELECT DISTINCT TYSHXYDM, ZZJGDM, ZCH, QYMC,1 ...       B1          NaN   \n",
       "\n",
       "   ...                                         TABLE_NAME TABLE_COMMENT  \\\n",
       "0  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "1  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "2  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "3  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "4  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "5  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "6  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "7  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "8  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "9  ...  DATASUMMARY.ORG_BASIC_INFO,LEGAL_ORG_TAG_MERGE...        企业基本信息   \n",
       "\n",
       "    REPOSITORY DOMAIN OWNER         CREATE_DATE IS_VALID  \\\n",
       "0  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "1  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "2  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "3  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "4  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "5  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "6  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "7  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "8  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "9  DATASUMMARY     机构   李从志  2021/1/30 15:37:43        1   \n",
       "\n",
       "                                              REMARK RANK VERSION  \n",
       "0  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...   97    V1.2  \n",
       "1                                                NaN   98    V1.2  \n",
       "2                                                NaN   99    V1.2  \n",
       "3  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...  100    V1.2  \n",
       "4                                                NaN  101    V1.2  \n",
       "5  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...  102    V1.2  \n",
       "6  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...  103    V1.2  \n",
       "7                                                NaN  104    V1.2  \n",
       "8  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...  105    V1.2  \n",
       "9  南山企服的企业信息表尽量使用统代、注册号或者组织机构代码匹配，因为他的企业名称比较不规范，存...  106    V1.2  \n",
       "\n",
       "[10 rows x 22 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e660527e",
   "metadata": {},
   "source": [
    ".info()  当前的信息"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "3d24c585",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 192 entries, 0 to 191\n",
      "Data columns (total 22 columns):\n",
      " #   Column          Non-Null Count  Dtype \n",
      "---  ------          --------------  ----- \n",
      " 0   ID              192 non-null    object\n",
      " 1   TAG_NAME        192 non-null    object\n",
      " 2   TAG_COMMENT     192 non-null    object\n",
      " 3   EFFECTIVE_DATE  192 non-null    object\n",
      " 4   INVALID_DATE    192 non-null    object\n",
      " 5   DATA_TYPE       192 non-null    object\n",
      " 6   BUSINESS_DESC   122 non-null    object\n",
      " 7   TECH_DESC       192 non-null    object\n",
      " 8   TAG_TYPE        100 non-null    object\n",
      " 9   IS_AUTHORITY    0 non-null      object\n",
      " 10  CYCLE           0 non-null      object\n",
      " 11  TABLE_NO        0 non-null      object\n",
      " 12  TABLE_NAME      192 non-null    object\n",
      " 13  TABLE_COMMENT   192 non-null    object\n",
      " 14  REPOSITORY      192 non-null    object\n",
      " 15  DOMAIN          192 non-null    object\n",
      " 16  OWNER           192 non-null    object\n",
      " 17  CREATE_DATE     192 non-null    object\n",
      " 18  IS_VALID        192 non-null    object\n",
      " 19  REMARK          92 non-null     object\n",
      " 20  RANK            192 non-null    object\n",
      " 21  VERSION         192 non-null    object\n",
      "dtypes: object(22)\n",
      "memory usage: 33.1+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "38b1e1ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RangeIndex(start=0, stop=192, step=1)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "002b3f98",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['ID', 'TAG_NAME', 'TAG_COMMENT', 'EFFECTIVE_DATE', 'INVALID_DATE',\n",
       "       'DATA_TYPE', 'BUSINESS_DESC', 'TECH_DESC', 'TAG_TYPE', 'IS_AUTHORITY',\n",
       "       'CYCLE', 'TABLE_NO', 'TABLE_NAME', 'TABLE_COMMENT', 'REPOSITORY',\n",
       "       'DOMAIN', 'OWNER', 'CREATE_DATE', 'IS_VALID', 'REMARK', 'RANK',\n",
       "       'VERSION'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "19aba586",
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrame' object has no attribute 'dtype'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "Cell \u001b[1;32mIn[21], line 1\u001b[0m\n\u001b[1;32m----> 1\u001b[0m df\u001b[38;5;241m.\u001b[39mdtype\n",
      "File \u001b[1;32mD:\\ProgramData\\Anaconda3\\Lib\\site-packages\\pandas\\core\\generic.py:5902\u001b[0m, in \u001b[0;36mNDFrame.__getattr__\u001b[1;34m(self, name)\u001b[0m\n\u001b[0;32m   5895\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m (\n\u001b[0;32m   5896\u001b[0m     name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_internal_names_set\n\u001b[0;32m   5897\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_metadata\n\u001b[0;32m   5898\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m name \u001b[38;5;129;01mnot\u001b[39;00m \u001b[38;5;129;01min\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_accessors\n\u001b[0;32m   5899\u001b[0m     \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_info_axis\u001b[38;5;241m.\u001b[39m_can_hold_identifiers_and_holds_name(name)\n\u001b[0;32m   5900\u001b[0m ):\n\u001b[0;32m   5901\u001b[0m     \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m[name]\n\u001b[1;32m-> 5902\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mobject\u001b[39m\u001b[38;5;241m.\u001b[39m\u001b[38;5;21m__getattribute__\u001b[39m(\u001b[38;5;28mself\u001b[39m, name)\n",
      "\u001b[1;31mAttributeError\u001b[0m: 'DataFrame' object has no attribute 'dtype'"
     ]
    }
   ],
   "source": [
    "df.dtyp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b9686fd2",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
